﻿/*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ChgDoc.Entity;
using ChgDoc.Extension;
using SqliteORM;

namespace ChgDoc.Render
{
    public class TemplateSqlRenderParameters : ResponseRenderParameters<TemplateSqlRenderParameters>
	{
		public long TemplateId { get; set; }
		public string Sql { get; set; }
		public string Param { get; set; }
        public long CacheDurationSeconds { get; set; }
	}

    public class TemplateSqlRender : ResponseRender
    {
    	private readonly TemplateSqlRenderParameters _parameters;
        
        public TemplateSqlRender(string constructionString)
        {
        	_parameters = TemplateSqlRenderParameters.Deserialize( constructionString );
        }

        public override void Render(System.Web.HttpContext context)
        {
            TemplateRender.TryFromCache( context, context.Request.RawUrl.ToLower(), _parameters.CacheDurationSeconds, 
                () =>
                {
        	        var template = Template.Read( _parameters.TemplateId );
			        if (template == null)
				        return string.Empty;
                        
                    List<dynamic> result;
                    using (var reader = new DirectSql())
                        result = reader.ExecuteDynamic(_parameters.Sql, _parameters.Param.FromMagicString().ToList() ).ToList();

                    var util = new UtilModelData() { Config = Config.Current, Tools = new Toolbox(template), Visitor = Visitor.Current, Data = result };

                    return TemplateRender.RenderRazor( template, util );
                } );
        }

    }
}
